package com.sinosoft.perfect.system._;

import java.sql.SQLException;
import java.util.List;

import com.sinosoft.perfect.system._.po.TLoginLog;
import com.sinosoft.perfect.system._.po.TResourceSystem;
import com.sinosoft.perfect.system._.po.TRoleSystem;
import com.sinosoft.perfect.system._.po.TUnit;
import com.sinosoft.perfect.system._.po.TUser;
import com.sinosoft.perfect.system._.po.TUserImg;
import com.sinosoft.perfect.system._.vo.LoginUser;
import com.sinosoft.perfect.system._.vo.LoginWroksiteUnitValidate;
import com.sinosoft.perfect.system._.vo.ResourceURLPower;
import com.sinosoft.perfect.system._.vo.SortNumber;
import com.sinosoft.perfect.system._.vo.UploadAttach;

public interface MapperSystem {

	public String validateLogin(TUser tuserInfo) throws SQLException;

	public List<LoginWroksiteUnitValidate> queryValidateLoginWorkSiteIp(String userId) throws SQLException;

	public LoginUser selectLoginUserInfoByUsername(String username) throws SQLException;

	public void insertLogByTLoginLog(TLoginLog tloginLog) throws SQLException;

	public List<TUnit> selectLoginUserInfoOfUnitsByUserId(String userId) throws SQLException;

	public List<TRoleSystem> selectLoginUserInfoOfRoleSystemsByUserId(String userId) throws SQLException;

	public void updateLogoutByPrimaryKey(String logId) throws SQLException;

	public void registerLoginStatus(String loginId) throws SQLException;

	public TUserImg selectLoginImgInfo(String userMainId) throws SQLException;

	public List<TResourceSystem> selectResourceOfRoleSystemsByUserId(String userId) throws SQLException;

	public List<TResourceSystem> selectResourceOfRoleSystemsByUserIdAdmin() throws SQLException;

	public List<ResourceURLPower> selectResourceInitMainPageByUserIdAndResourceId(ResourceURLPower resourceURLPower) throws SQLException;

	public SortNumber selectSortHisoryInfo(SortNumber sortNumberParam) throws SQLException;

	public void updateSort(SortNumber sortNumber) throws SQLException;

	public void updateSortDown(SortNumber sortNumber) throws SQLException;

	public void updateSortUp(SortNumber sortNumber) throws SQLException;

	public void deleteAttach(UploadAttach uploadAttach) throws SQLException;

	public void insertAttach(UploadAttach uploadAttach) throws SQLException;

	public List<String> selectOnlineUsers(String userIds) throws SQLException;

	public SortNumber selectSortHisoryInfoRelation(SortNumber sortNumber) throws SQLException;

	public void updateSortUpRelation(SortNumber sortNumber) throws SQLException;

	public void updateSortDownRelation(SortNumber sortNumber) throws SQLException;

	public void updateSortRelation(SortNumber sortNumber) throws SQLException;

	public SortNumber selectSortHisoryInfoNoSuper(SortNumber sortNumber) throws SQLException;

	public void updateSortUpNoSuper(SortNumber sortNumber) throws SQLException;

	public void updateSortDownNoSuper(SortNumber sortNumber) throws SQLException;

	public void updateSortNoSuper(SortNumber sortNumber) throws SQLException;

}
